How to: Set Up Redistribution Templates

To set up Store Stock Redistribution, you must create Replenishment Templates of type Redistribution. This topic describes the specific setup for Redistribution Templates. The See Also section at the bottom of this page has links to help pages for generic Replenishment Template setup.

To set up a Redistribution Template

  1. Click the icon, enter Replen. Template List, and select the relevant link.
  2. Click New action to create a new template.
  3. Fill in field values and filters as shown below.

Fields

Field Description
Replenishment Type This field specifies whether the Replenishment Template is to be used for Store Stock Redistribution, or for creating Purchase Orders or Transfer Orders. The selection Redistribution is used for Store Stock Redistribution.
Redistribution Calculation Type This field specifies the type, how the system calculates the Redist. Stock and Redist. Demand.
The available options are:
  • Sales Demand
  • Stock Balancing
  • Reorder Point/Max. Inventory
  • Manual Redistribution

For more information see Redistribution Calculation Types.

Redistribution Strategy This field specifies the strategy, how the system calculates the trips between stores with Redist. Stock and Redist. Demand. The available options are:
  • Least No. of Trips
  • Least Cost
  • Shortest Distance (Direct)
  • Shortest Distance (Route)
  • Shortest Duration (Route)

For more information see Redist. Strategies.

Create Journal Lines This check box specifies if the Redist. Journal is calculated in one or two steps. The available options are:
  • Create Redist. Preview Only
  • Create Redist. Preview and Journal Lines

The first option only calculates the Redist. Preview. The user can manually review the results, adjust, and calculate the Journal Lines in a second step.
The second option calculates the Redist. Preview and Journal Lines in one step.

Note: This field is not applicable for Redist. Calculation Type Manual Redistribution.

Redistribution Buffer Calculation The field specifies a buffer quantity to be reserved in locations that serve as supplying location in Store Stock Redistribution. The available inventory in the location is reduced by the Redistribution Buffer Value % to calculate the Redistributable Stock. The field Redistribution Buffer Calculation defines the basis for this calculation. This field is only applicable if the Redist. Calculation Type is Sales Demand.

When a new Replenishment Template of type Redistribution is created, this field is copied over to the template from the Replen. Setup.

Redistribution Buffer Value % The field is used to reserve a buffer quantity in locations that serve as supplying location in Store Stock Redistribution. The available inventory in the location is reduced by the Redistribution Buffer Value % to calculate the Redistributable Stock. The field Redistribution Buffer Calculation defines the basis for this calculation. This field is only applicable if the Redist. Calculation Type is Sales Demand.

When a new Replenishment Template of type Redistribution is created, this field is copied over to the template from the Replen. Setup.

Redistribution Warehouse Stock This field is applicable for Store Stock Redistribution and it defines how available stock in the warehouse is treated. The available option values are:
  • Ignore
  • Force
  • Prioritize
  • Like Store Stock

For more information see Warehouse in Redistribution.

Date Calculation Type This field specifies whether the start date and end date will be entered manually or calculated based on a given date formula.
Start Date This field specifies the start date to be used for store stock redistribution calculation. This is the starting date to be based on when calculating sales information, such as Qty. Sold until Today, Sell Through %, and Average Daily Sales. It is automatically assigned with the season's starting date if a Season Code is selected. This is used when the Date Calculation Type is Date.
End Date This field specifies the end date to be used for store stock redistribution calculation. This is the ending date to be based on when calculating sales information such as Demand until End Date. It is automatically assigned with the season's ending date, if a Season Code is selected. This is used when the Date Calculation Type is Date and the Redist. Calculation Type is Sales Demand or Manual Redistribution.
Start Date Formula This field specifies the formula to calculate the start date for store stock redistribution calculation. This is used when the Date Calculation Type is Date Formula.
End Date Formula This field specifies the formula to calculate the end date for store stock redistribution calculation. This is used when the Date Calculation Type is Date Formula and the Redist. Calculation Type is Sales Demand or Manual Redistribution.

Filters

On the Replen. Template page you can define the filters that you would like to apply to the Item table when you add items to the Replenishment Journals.

Filter Description
Vendor No. Filter This field specifies a filter for the Vendor No. field of the item. For example, you can enter the value of 1000 to exclude all the items that are supplied by Vendor No. 1000.

Note: You can also specify a range of Vendor No. to be excluded, for example 1000...2000, and the system will exclude all items which are supplied by vendor number 1000 to 2000.

Item Category Filter This field specifies a filter for the Category Code field of the item. Items belonging to this Item Category will be considered in the calculation.
Item Product Group Filter This field specifies a filter for the Product Group Code field of the item. Items belonging to this Item Product Group will be considered in the calculation.
Item No. Filter This field specifies a filter for the item number.
Special Group Code Filter This field specifies a filter for Special Groups. Items belonging to this Special Group will be considered in the calculation.
Item Attribute Filter This field specifies a filter for Attributes. Items belonging to this Attribute will be considered in the calculation.
Variant Dimension Filter This field specifies a filter for Variant Dimension Values. Items belonging to this Variant Dimension will be considered in the calculation.
From Location Filter
To Location Filter
This field specifies filters for From Location and To Location.
When Store Stock Redistribution calculates the inventory in the locations, it classifies locations into Supply Locations (From Location Filter) and Demand Locations (To Location Filter). These filters will set locations to the status Excluded in Store Stock Redistribution when the Calculation Type Sales Demand or Manual Redistribution is used. For the other Calculation Types, these stores will not appear in the Preview and Journal Lines as they have been filtered out.

See Also

Store Stock Redistribution

Replenishment Templates

Replenishment Journals

Replenishment Batch